# from django.test import TestCase
#
# # Create your tests here.
# import pymysql
#
# conn = pymysql.connect(host='localhost', port=3306, user='root', password='root', charset='utf8', db='shiyanlou02')
# curent=conn.cursor()
# #
# sql_user='''create table sql_user(id int unsigned primary key  not null auto_increment,
#        username varchar (120),
#        password varchar (200),
#        phone INTEGER ,
#        email varchar (20),
#        adress varchar (230),
#        status enum('未激活','激活') default '未激活'
#
#
#        )'''
#
# sql_third = '''create table third(id int unsigned primary key not null auto_increment,
#            third_id INTEGER ,
#            third_name varchar (200),
#            phone INTEGER ,
#            email varchar (20),
#            adress varchar (230),
#            status enum('未绑定','绑定') default '未绑定'
#            )'''
# # sql_Fatie = '''create table fatie(id int unsigned primary key not null auto_increment,
# #                uid_id INTEGER ,
# #                title varchar (200),
# #                content varchar (200),
# #                store_num INTEGER,
# #                like_num INTEGER ,
# #                status enum('删除','未删除') default '删除'
# #                )'''
# #
# # Storer_Liker = '''create table like01(id int unsigned primary key not null auto_increment,
# #                uid_id INTEGER,
# #                fatie INTEGER,
# #                status enum('未点赞','点赞') default '未点赞'
# #                )'''
# # Storer_Reply = '''create table reply(id int unsigned primary key not null auto_increment,
# #                fatie INTEGER ,
# #                R_Uid INTEGER
# #
# #                )'''
# # Storer_Code = '''create table code(id int unsigned primary key not null auto_increment,
# #                uid_id INTEGER ,
# #                code varchar(20),
# #
# #                status enum('激活','改密码','过期','未过期') default'激活'
# #                )'''
# # sql_Visitor = '''create table vistor(id int unsigned primary key not null auto_increment,
# #                uid INTEGER,
# #                fatie INTEGER,
# #                status enum('删除','未删除') default '删除'
# #                )'''
# # sql_Change_Password = '''create table Change_Password02(id int unsigned primary key not null auto_increment,
# #                uid INTEGER,
# #                code varchar (20),
# #                status enum('邮箱改密码','手机号改密码','自己改密码') default '邮箱改密码'
# #                )'''
# sql='''create table student01(
#         id  int unsigned not null primary key auto_increment,
#         name varchar(20) not null,
#         age int unsigned ,
#         high decimal(5,2),
#         clas_id int unsigned,
#         gender enum('中性','男','女') default'女',
#         ctime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
#         uptime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间')
#         '''
#
# curent.execute(sql)